<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>layui</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
    <link rel="stylesheet" href="../lib/layui-v2.6.3/css/layui.css" media="all">
    <link rel="stylesheet" href="../css/public.css" media="all">
</head>
<body>
<div class="layuimini-container">
    <div class="layuimini-main">

        <fieldset class="table-search-fieldset">
            <legend>搜索信息</legend>
            <div style="margin: 10px 10px 10px 10px">
                <form class="layui-form layui-form-pane" action="">
                    <div class="layui-form-item">


                        <div class="layui-inline">
                            <label class="layui-form-label">请选择时间范围</label>
                            <div class="layui-input-inline">
                                <input type="text" name="hhiredate" class="layui-input" id="test16" placeholder="开始 到 结束">
                            </div>
                        </div>


                        <div class="layui-inline">

                            <div class="layui-input-inline">
                                <input type="text" name="hname" autocomplete="off" class="layui-input" placeholder="请输入要搜索的小区名">
                            </div>
                        </div>

                        <div class="layui-inline">
                            <button type="submit" class="layui-btn layui-btn-primary"  lay-submit lay-filter="data-search-btn"><i class="layui-icon"></i> 搜 索</button>
                        </div>
                    </div>
                </form>
            </div>
        </fieldset>
        <button type="button" class="layui-btn  layui-btn-sm " id="test3"><i class="layui-icon"></i>导入Excel</button>
        <button type="button" class="layui-btn  layui-btn-sm " id="test4" onclick="downloadExcel()"><i class="layui-icon"></i>导出为Excel</button>
        <script type="text/html" id="toolbarDemo">
            <div class="layui-btn-container">

                <button class="layui-btn layui-btn-sm layui-btn-danger data-delete-btn" lay-event="delete"> 批量删除 </button>
                <button class="layui-btn layui-btn-normal layui-btn-sm data-add-btn" lay-event="add">添加</button>


            </div>
        </script>

        <table class="layui-hide" id="currentTableId" lay-filter="currentTableFilter"></table>

        <script type="text/html" id="currentTableBar">
            <a class="layui-btn layui-btn-normal layui-btn-xs data-count-edit" lay-event="edit">编辑</a>
            <a class="layui-btn layui-btn-xs layui-btn-danger data-count-delete" lay-event="delete">删除</a>
        </script>

    </div>
</div>
<script src="../lib/layui-v2.6.3/layui.js" charset="utf-8"></script>
<script>
    //导出excel
    function downloadExcel(){
        location.href="/housing?methodName=download"
    }
    layui.use(['form', 'table','layer','laydate','upload'], function () {
        var $ = layui.jquery,
            form = layui.form,
            layer = layui.layer,
            upload = layui.upload,
            laydate = layui.laydate,
            table = layui.table;

        //日期范围
        laydate.render({
            elem: '#test16'
            ,type: 'date'
            ,range: '到'
            ,format: 'yyyy年M月d日'
        });
        //导入xls表格
        upload.render({ //允许上传的文件后缀
            elem: '#test3'
            ,url: '/housing?methodName=uploadExcel' //此处配置你自己的上传接口即可
            ,accept: 'file' //普通文件
            ,exts: 'xls|xlsx' //只允许上传压缩文件
            ,done: function(res){
                layer.msg('上传成功');
                console.log(res);
                table.reload("currentTableId");
            }
        });

        table.render({
            elem: '#currentTableId',
            url: '/housing?methodName=search',
            toolbar: '#toolbarDemo',
            defaultToolbar: ['filter', 'exports', 'print', {
                title: '提示',
                layEvent: 'LAYTABLE_TIPS',
                icon: 'layui-icon-tips'
            }],
            cols: [[
                {type: "checkbox", width: 50},
                {field: 'hid', width: 80, title: 'ID', sort: true},
                {field: 'hnumber', width: 120, title: '小区编号', sort: true},
                {field: 'hname', width: 120, title: '小区名称', sort: true},
                {field: 'hplace', width: 120, title: '坐落地址'},
                {field: 'placearea', title: '占地面积（m2）', width: 120, sort: true},
                {field: 'bcount', width: 80, title: '总栋数'},
                {field: 'rcount', width: 80, title: '总户数'},
                {field: 'greeningrate', width: 120, title: '绿化率（%）'},
                {field: 'himage', width: 100, title: '缩略图' ,templet: function(res){ //res指的是emp对象
                        if(res.himage == null || res.himage == '' || res.himage == undefined){
                            return `<img src="/upload/8.jpg" width="80px" height="80px">`
                        }
                        return `<img src="/upload/${res.himage}" width="80px" height="80px">`
                    }},
                {field: 'developer', width: 120, title: '开发商名称', sort: true},
                {field: 'property', width: 150, title: '物业公司名称', sort: true},
                {field: 'hhiredate', width: 120, title: '创建时间', sort: true},
                {title: '操作', minWidth: 150, toolbar: '#currentTableBar', align: "center"}
            ]],
            limits: [1 ,5, 10, 15, 20, 25, 50, 100],
            limit: 15,
            page: true,
            skin: 'line'
        });

        // 监听搜索操作
        form.on('submit(data-search-btn)', function (data) {
            var result = JSON.stringify(data.field);


            table.reload('currentTableId', {
                page: {
                    curr: 1
                }
                , where: {
                    hname:data.field.hname,
                    hhiredate:data.field.hhiredate,
                }
            }, 'data');

            return false;
        });

        /**
         * toolbar监听事件
         */
        table.on('toolbar(currentTableFilter)', function (obj) {
            if (obj.event === 'add') {  // 监听添加操作
                var index = layer.open({
                    title: '添加用户',
                    type: 2,
                    shade: 0.2,
                    maxmin:true,
                    shadeClose: true,
                    area: ['100%', '100%'],
                    content: '../page/table/housingadd.html',
                    end:function(){
                        //重载表格
                        table.reload("currentTableId");
                    }
                });
                $(window).on("resize", function () {
                    layer.full(index);
                });
            } else if (obj.event === 'delete') {  // 监听批量删除操作
                var checkStatus = table.checkStatus('currentTableId')
                    , data = checkStatus.data;

                //layer.alert(JSON.stringify(data));
//发送Ajax异步请求。
                $.post({
                    url:'/housing?methodName=deleteAll',
                    data:{
                        housings:JSON.stringify(data)
                    },
                    success:function(res){
                        if(res.code == 0){ //删除成功
                            table.reload("currentTableId");
                        }
                        layer.msg(res.msg);
                    }
                })

            }
        });

        //监听表格复选框选择
        table.on('checkbox(currentTableFilter)', function (obj) {
            console.log(obj)
        });

        table.on('tool(currentTableFilter)', function (obj) {
            var data = obj.data;
            if (obj.event === 'edit') {
                sessionStorage.setItem("hid",data.hid);
                var index = layer.open({
                    title: '编辑用户',
                    type: 2,
                    shade: 0.2,
                    maxmin:true,
                    shadeClose: true,
                    area: ['100%', '100%'],
                    content: '../page/table/housingedit.html',
                    end:function(){
                        //重载表格
                        table.reload("currentTableId");
                        //location.reload();
                    }
                });
                $(window).on("resize", function () {
                    layer.full(index);
                });
                return false;
            } else if (obj.event === 'delete') {
                layer.confirm('真的删除行么', function (index) {
                    $.post({
                        url:"/housing?methodName=del",
                        data:{hid:data.hid},
                        success:function (res) {
                            if (res.code==0){
                                layer.alert(res.msg)
                            }else {
                                layer.alert(res.msg)
                            }
                        }
                    })
                    obj.del();
                    layer.close(index);
                });
            }
        });

    });
</script>

</body>
</html>